<%@page import="webkf.Ljsq"%>
<%@page import="webkf.Spgl"%>
<%@page import="webkf.SP"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%
  String path = request.getContextPath();
  String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<html>
<head>

  <base href="<%=basePath %>>">
  <title>My JSP 'index.jsp' starting page</title>
  <meta http-equiv="pragma" content="no-cache">
  <meta http-equiv="cache-control" content="no-cache">
  <meta http-equiv="expires" content="0">
  <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  <meta http-equiv="description" content="This is my page">


</head>

<html>
  <head>
    <title>dxfhdf</title>
  </head>
  <body>
 <%
   Spgl gl=new Spgl();
   ArrayList<SP> ar=gl.listAllSP();
   out.println("<table>");
   for (SP df:ar) {
     out.println("<tr>");
     out.println("<td>"+df.getId()+"</td>");
     out.println("<td>"+df.getName()+"</td>");
     out.println("<td>"+df.getJg()+"</td>");
     out.println("/tr");
   }
   out.println("</table>");
 %>
  </body>
</html>
